package cn.edu.zhku.citrusmonitor.qa.dao;

import java.sql.SQLException;
import java.util.List;

import cn.edu.zhku.citrusmonitor.domain.TbAnswer;
import cn.edu.zhku.citrusmonitor.domain.TbQuestion;

public interface QuestionDao {

	public void addQ(TbQuestion question) throws SQLException;

	public int removeQ(String questionId) throws SQLException;

	public int modifyQ(TbQuestion question) throws SQLException;

	public List<TbQuestion> findQAByWord(String content) throws SQLException;

	List<TbQuestion> showQ(int currentPage, int pageSize, String status) throws SQLException;

	public TbQuestion findQyByQid(String questionId) throws SQLException;

	public TbAnswer findAByQid(String questionId) throws SQLException;

	public List<TbQuestion> showQAll(int pageSize) throws SQLException;

	int count(String status) throws SQLException;

	public String findUserPasswordById(String userId) throws SQLException;

	public int count() throws SQLException;

	public List<TbQuestion> showAll(int currentPage, int pageSize) throws SQLException;

	public int delAll(String[] ids) throws SQLException;


}
